<?php include("head.php"); ?>
    <div class="sui-layout">
		  <div class="sidebar">
<?php include("leftmenu.php"); ?>	  	
		  </div>
		  <div class="content">
          <p class="sui-text-xxlarge my-padd">成绩录入</p>
			<form action="chengji_save.php" method="get" class="sui-form form-horizontal sui-validate">
			  <input type="hidden" name="action" value="add">
			  <div class="control-group">
			    <label for="inputEmail" class="control-label">课程名称:</label>
			    <div class="controls">
				  <!-- <input name="kcbianhao" type="text" id="kcbianhao" class="input-large input-fat"  data-rules="required|minlength=2|maxlength=10" placeholder="输入课程编号"> -->
				  <select name="kcbianhao">
				  <?php 
					  include("conn.php");
					  $sql = "select * from 课程";
					  $result = mysqli_query($conn,$sql);
					  if(mysqli_num_rows($result)>0){
						  while($arr = mysqli_fetch_assoc($result)){
							  echo "<option value='{$arr['课程编号']}'>{$arr['课程名称']}</option>";
						  }
					  }else{
						  echo "<option value=''>暂无记录</option>";
					  }
					//   mysqli_close($conn);
				  ?>
				  </select>
				  <!-- <select name="kcbianhao" id="">
					  <option value="a003"></option>
				  </select> -->
			    </div>
              </div>
			  <div class="control-group">
			    <label for="inputEmail" class="control-label">学号：</label>
			    <div class="controls">
				  <!-- <input name="xuehao" type="text" id="xuehao" class="input-large input-fat" placeholder="输入学号" data-rules="required|minlength=2|maxlength=10"> -->
				  <select name="xuehao">
				  <?php 
					  include("conn.php");
					  $sql = "select * from student";
					  $result = mysqli_query($conn,$sql);
					  if(mysqli_num_rows($result)>0){
						  while($arr = mysqli_fetch_assoc($result)){
							  echo "<option value='{$arr['学号']}'>{$arr['学号']}</option>";
						  }
					  }else{
						  echo "<option value=''>暂无记录</option>";
					  }
					  mysqli_close($conn);
				  ?>
				  </select>
			    </div>
			  </div>
              <div class="control-group">
			    <label for="inputEmail" class="control-label">成绩：</label>
			    <div class="controls">
			      <input name="chengji" type="text" id="chengji" class="input-large input-fat" placeholder="输入成绩" data-rules="required|minlength=2|maxlength=10">
			    </div>
			  </div>	
			  <div class="control-group">
			  	<label class="control-label"></label>
			  	<div class="controls">
			  		<input type="submit" value="提交" name="" class="sui-btn btn-large btn-primary">
			  	</div>
			  </div>	  
			</form>
		  </div>
		</div>		
    </div>
<?php include("foot.php"); ?>